---
title: "SQL-035: Retrieve vocational service type code table"
summary: Retrieve vocational service type code table
status: draft
owner: SAIF Documentation Generator
last_reviewed: 2026-08-21
library: SAIF.Business.Claim
reference_type: embedded
---

# SQL-035 Retrieve vocational service type code table

Retrieves the full vocational reserve service-type reference/code table.

## Classification



| Field | Value |
| --- | --- |
| **SQL ID** | SQL-035 |
| **Operation type** | Read |
| **Execution method** | Inline SQL (SqlHelper.ResultSetQuery) |
| **Database** | Oracle |
| **Schema** | `[unqualified]**` |
| **Command type** | Text |
| **Business object** | `clsVocationalServicesTypes` |
| **Criteria property** | `(none)` |
| **Lifecycle method** | `GetVocationalServiceTypes` |

## Tables



| Table | Access | Columns used |
| --- | --- | --- |
| [CL_RESERVE_VOC_SERV_TYPE_CODE](../database-tables.md#cl_reserve_voc_serv_type_code) | SELECT | * (full code table) |

## Sample SQL

```sql
-- Retrieve vocational service type code table
select *
  from cl_reserve_voc_serv_type_code
```

## Operations and processes

- [Code-table caching](../operations/code-table-caching.md)

## Sources
- SAIF.Business.Claim/clsVocationalServicesTypes.vb